from utility.pgsql_manager import PgSqlManager

pgDB = PgSqlManager().get_instance()
# log表模型
class PhysicalModel(pgDB.Model):
    __tablename__ = 'inspection_physical'
    id = pgDB.Column(pgDB.Integer, primary_key=True, doc='体格检查Id')
    create_uid = pgDB.Column(pgDB.Integer)
    write_uid = pgDB.Column(pgDB.Integer)
    archives_id = pgDB.Column(pgDB.Integer, pgDB.ForeignKey('res_archives.id'))
    inspection_log_id = pgDB.Column(pgDB.Integer, pgDB.ForeignKey('inspection_physical.id'))
    cg_ssy = pgDB.Column(pgDB.Integer)
    cg_szy = pgDB.Column(pgDB.Integer)
    cg_xl = pgDB.Column(pgDB.Integer)
    cg_tw = pgDB.Column(pgDB.Integer)
    cg_hx = pgDB.Column(pgDB.Integer)
    hospital_id = pgDB.Column(pgDB.Integer)
    type = pgDB.Column(pgDB.String)
    cg_fz = pgDB.Column(pgDB.String)
    cg_gs = pgDB.Column(pgDB.String)
    cg_xj = pgDB.Column(pgDB.String)
    cg_rsqyc = pgDB.Column(pgDB.String)
    cg_chts = pgDB.Column(pgDB.String)
    cg_chccyj = pgDB.Column(pgDB.String)
    yb_zl = pgDB.Column(pgDB.String)
    yb_zl_ycms = pgDB.Column(pgDB.String)
    yb_jszt = pgDB.Column(pgDB.String)
    yb_jszt_ycms = pgDB.Column(pgDB.String)
    yb_wg = pgDB.Column(pgDB.String)
    yb_wg_ycms = pgDB.Column(pgDB.String)
    yb_tszt = pgDB.Column(pgDB.String)
    yb_tszt_ycms = pgDB.Column(pgDB.String)
    yb_tsmr = pgDB.Column(pgDB.String)
    yb_tsmr_ycms = pgDB.Column(pgDB.String)
    yb_pfmf = pgDB.Column(pgDB.String)
    yb_pfmf_ycms = pgDB.Column(pgDB.String)
    yb_jzx = pgDB.Column(pgDB.String)
    yb_jzx_ycms = pgDB.Column(pgDB.String)
    yb_fb = pgDB.Column(pgDB.String)
    yb_fb_ycms = pgDB.Column(pgDB.String)
    yb_xlbq = pgDB.Column(pgDB.String)
    yb_xlbq_ycms = pgDB.Column(pgDB.String)
    yb_xzzy = pgDB.Column(pgDB.String)
    yb_xzzy_ycms = pgDB.Column(pgDB.String)
    yb_gp = pgDB.Column(pgDB.String)
    yb_gp_ycms = pgDB.Column(pgDB.String)
    yb_szjz = pgDB.Column(pgDB.String)
    yb_szjz_ycms = pgDB.Column(pgDB.String)
    yb_qt = pgDB.Column(pgDB.String)
    fk_ym = pgDB.Column(pgDB.String)
    fk_ym_ycms = pgDB.Column(pgDB.String)
    fk_rf = pgDB.Column(pgDB.String)
    fk_rf_ycms = pgDB.Column(pgDB.String)
    fk_wy = pgDB.Column(pgDB.String)
    fk_wy_ycms = pgDB.Column(pgDB.String)
    fk_yd = pgDB.Column(pgDB.String)
    fk_yd_ycms = pgDB.Column(pgDB.String)
    fk_fmw = pgDB.Column(pgDB.String)
    fk_fmw_ycms = pgDB.Column(pgDB.String)
    fk_gj = pgDB.Column(pgDB.String)
    fk_gj_ycms = pgDB.Column(pgDB.String)
    fk_scfj = pgDB.Column(pgDB.String)
    fk_scfj_ycms = pgDB.Column(pgDB.String)
    fk_zg = pgDB.Column(pgDB.String)
    fk_zg_ycms = pgDB.Column(pgDB.String)
    fk_el = pgDB.Column(pgDB.String)
    fk_el_ycms = pgDB.Column(pgDB.String)
    fk_sk = pgDB.Column(pgDB.String)
    fk_sk_ycms = pgDB.Column(pgDB.String)
    fk_qt = pgDB.Column(pgDB.String)
    pg_gpn_dj = pgDB.Column(pgDB.String)
    pg_gpn_dahd = pgDB.Column(pgDB.String)
    pg_gpn_dwgjhdd = pgDB.Column(pgDB.String)
    pg_gpn_wg = pgDB.Column(pgDB.String)
    pg_gpn_cgghd = pgDB.Column(pgDB.String)
    pg_gpn_sczgj = pgDB.Column(pgDB.String)
    pg_gjgl_gkkd = pgDB.Column(pgDB.String)
    pg_gjgl_gjgxt = pgDB.Column(pgDB.String)
    pg_gjgl_gjyd = pgDB.Column(pgDB.String)
    pg_gjgl_xlwz = pgDB.Column(pgDB.String)
    pg_gjgl_xlbgd = pgDB.Column(pgDB.String)
    pg_gjgl_bishops = pgDB.Column(pgDB.String)
    jcjg = pgDB.Column(pgDB.String)
    create_date = pgDB.Column(pgDB.Integer)
    write_date = pgDB.Column(pgDB.Integer)
    cg_tjrq = pgDB.Column(pgDB.Integer)
    cg_sg = pgDB.Column(pgDB.Float)
    cg_tz = pgDB.Column(pgDB.Float)
    cg_bmi = pgDB.Column(pgDB.Float)
    cg_yqtz = pgDB.Column(pgDB.Float)
    cg_yqbmi = pgDB.Column(pgDB.Float)
    cg_fw = pgDB.Column(pgDB.Float)
    cg_gg = pgDB.Column(pgDB.Float)
    pg_pgcl_zgjjj = pgDB.Column(pgDB.Float)
    pg_pgcl_qqjj = pgDB.Column(pgDB.Float)
    pg_pgcl_dcwj = pgDB.Column(pgDB.Float)
    pg_pgcl_zgjjjj = pgDB.Column(pgDB.Float)
    pg_gpn_zgqjkd = pgDB.Column(pgDB.Float)
    pg_gpn_zghjhd = pgDB.Column(pgDB.Float)


